package com.guigu.www.erp.dehao.dao;

import com.guigu.www.erp.common.pojo.MApply;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface MApplyMapper {
    int deleteByPrimaryKey(Integer id);
    int insertSelective(MApply record);
    MApply selectByPrimaryKey(Integer id);
    int updateByPrimaryKeySelective(MApply record);
    List<MApply> findLikeMApply(@Param("productName") String productName,
                                @Param("startTime")String startTime,
                                @Param("endTime")String endTime,
                                @Param("dept_id")Integer dept_id);


    List<MApply> queryLikeMApply(@Param("applyId") String applyId,
                                @Param("productName") String productName,
                                    @Param("startTime")String startTime,
                                    @Param("endTime")String endTime);

    int insert(MApply record);
    int updateByPrimaryKey(MApply record);

    //查询通过审核的产品设计表
    List<MApply> selectBycheckTag1();

    //查询最大的生产计划表编号
    String queryMaxApplyId();

    //根据applyId查
    List<MApply> queryByApplyId(String applyId);

    //根据applyId修改
    void updateByApplyId(MApply mApply);

    //查询各个状态的总数
    Integer numberCheckTag0();
    Integer numberCheckTag1();
    Integer numberCheckTag2();

    //查询通过审核并没有派工的数据
    List<MApply> queryByCheckMApply1();

    //查询通过审核并没有派工的条数
    Integer numberManufactureTagGroup0();
    Integer numberManufactureTag0();
}